<%@ page import="java.sql.*, studentportal.*"%>
<html>

<head>
 
<title>New Page 1</title>
</head>

<body topmargin=0 leftmargin=0 background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<font face="Trebuchet MS, Arial, Helvetica">
<table border="0" width="100%">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>


<%
					String name=request.getParameter("NAME");
					String author=request.getParameter("AUTHOR");
					String edition=request.getParameter("EDITION");
					String isbn=request.getParameter("ISBN");
					String year=request.getParameter("YEAR");
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statement");
					String sr="insert into book_master(  book_name, author, edition,isbn, purchased_date) values('"+name+"','"+author+"','"+edition+"','"+isbn+"','"+year+"')";
					System.out.println(sr);
					int rs=0;
					rs=st.executeUpdate(sr);
					st.close();
					con.close();
if(rs>0){
%>
  <table border="0" width="100%" height="211">
    <tr>
      <td width="100%" height="69">
        <p align="center"><font size="6" color="#0000FF"><b>Congragulations</b></font></td>
    </tr>

    <tr>
      <td width="100%" height="68">
        <p align="center"><font size="6" color="#0000FF"><b>Your's Insert Operation is Sucessfull</b></font></td>
    </tr>
    <tr>
      <td width="100%" height="68">
        <p align="center"><a href="./AdminBookMasterEntry.jsp"><font size="5" color="#0000FF"><b>Back</b></font></a></td>
    </tr>

  </table>

<%} %>
</font>
<div align="center">
    <center>
  
</body>
  
</html>
